CREATE TABLE [dbo].[Rpt_TicketTbl]
(
[MEET_MASTER_TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_MEET_MASTER_TITLE] DEFAULT (''),
[PRODUCT_TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_PRODUCT_TITLE] DEFAULT (''),
[BEGIN_DATE_TIME] [datetime] NULL,
[END_DATE_TIME] [datetime] NULL,
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_FULL_NAME] DEFAULT (''),
[TICKET_NUMBER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_TICKET_NUMBER] DEFAULT (''),
[ORDER_NUMBER] [float] NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_ORDER_NUMBER] DEFAULT ((0)),
[UserID_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_UserID_Date] DEFAULT (''),
[BADGE_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_BADGE_TYPE] DEFAULT (''),
[LAST_FIRST] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_LAST_FIRST] DEFAULT (''),
[DESIGNATION] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_DESIGNATION] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_PRODUCT_CODE] DEFAULT (''),
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_COMPANY] DEFAULT (''),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Rpt_TicketTbl_IS_FR_ITEM] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iRpt_TicketTblORDER_NUMBER] ON [dbo].[Rpt_TicketTbl] ([ORDER_NUMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iRpt_TicketTblUserID_Date] ON [dbo].[Rpt_TicketTbl] ([UserID_Date]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Rpt_TicketTbl] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_TicketTbl] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_TicketTbl] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_TicketTbl] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_TicketTbl] TO [IMIS]
GO